Number of Row with given data is 1644
Number of Column with given data is 32
Total Count of missing data is 3944
top 5 data is below
EXMD_BZ_YYYY RN_INDI HME_YYYYMM Q_PHX_DX_STK Q_PHX_DX_HTDZ Q_PHX_DX_HTN Q_PHX_DX_DM Q_PHX_DX_DLD Q_PHX_DX_PTB Q_HBV_AG Q_SMK_YN
1 2009 562083 200909 0 0 1 0 0 NA 3 1
2 2009 334536 200911 0 0 0 0 0 NA 2 1
3 2009 911867 200903 0 0 0 0 0 NA 3 1
4 2009 183321 200908 NA NA NA NA NA NA 3 1
5 2009 942671 200909 NA NA NA NA NA NA 3 1
Q_DRK_FRQ_V09N HGHT WGHT WSTC BMI VA_LT VA_RT BP_SYS BP_DIA URN_PROT HGB FBS TOT_CHOL TG HDL LDL CRTN SGOT SGPT GGT GFR
1 0 144 61 90 29.4 0.7 0.8 120 80 1 12.6 117 264 128 60 179 0.9 25 20 25 59
2 0 162 51 63 19.4 0.8 1.0 120 80 1 13.8 96 169 92 70 80 0.9 18 15 28 74
3 0 163 65 82 24.5 0.7 0.6 130 80 1 15.0 118 216 132 55 134 0.8 26 30 30 79
4 0 152 51 70 22.1 0.8 0.9 101 62 1 13.1 90 199 100 65 114 0.9 18 14 11 61
5 0 159 50 73 19.8 0.7 0.8 132 78 1 13.0 92 162 58 40 111 0.9 24 23 15 49
last 5 data is below
EXMD_BZ_YYYY RN_INDI HME_YYYYMM Q_PHX_DX_STK Q_PHX_DX_HTDZ Q_PHX_DX_HTN Q_PHX_DX_DM Q_PHX_DX_DLD Q_PHX_DX_PTB Q_HBV_AG Q_SMK_YN
1640 2015 266734 201504 NA NA NA NA NA NA 1 2
1641 2015 343874 201511 0 0 0 1 0 0 2 2
1642 2015 798472 201507 NA NA NA NA NA NA 3 2
1643 2015 720080 201505 NA NA NA NA 1 NA 2 2
1644 2015 127519 201511 0 0 1 0 0 0 3 2
Q_DRK_FRQ_V09N HGHT WGHT WSTC BMI VA_LT VA_RT BP_SYS BP_DIA URN_PROT HGB FBS TOT_CHOL TG HDL LDL CRTN SGOT SGPT GGT GFR
1640 2 171 76 88 26.0 1.2 1.2 125 89 1 14.1 77 363 280 63 244 0.9 19 32 95 96
1641 0 179 80 88 25.0 1.0 0.7 126 83 1 14.9 119 106 247 29 50 0.9 101 157 62 79
1642 0 163 63 80 23.7 1.5 1.5 118 77 1 16.1 160 271 514 51 151 1.0 40 66 104 85
1643 1 165 70 92 25.7 0.6 0.8 120 80 1 13.6 81 289 810 52 NA 1.0 37 33 76 86
1644 4 168 84 103 29.8 0.9 0.8 140 85 1 15.2 134 210 298 56 94 1.1 55 49 66 66
| variable | n_miss | pct_miss |
|---|---|---|
| Q_PHX_DX_PTB | 703 | 42.7615572 |
| Q_PHX_DX_STK | 573 | 34.8540146 |
| Q_PHX_DX_HTDZ | 566 | 34.4282238 |
| Q_PHX_DX_DLD | 566 | 34.4282238 |
| Q_PHX_DX_DM | 547 | 33.2725061 |
| Q_PHX_DX_HTN | 492 | 29.9270073 |
| GFR | 467 | 28.4063260 |
| LDL | 16 | 0.9732360 |
| Q_DRK_FRQ_V09N | 6 | 0.3649635 |
| URN_PROT | 4 | 0.2433090 |
| Q_HBV_AG | 2 | 0.1216545 |
| Q_SMK_YN | 2 | 0.1216545 |
[1] “Number of Row Reduced to 1000”
| 1 Column name: | EXMD_BZ_YYYY |
|---|---|
| Unique non-mission value count: | 7 |
| Missing value count: | 0 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 2009 | 214 | 214 | 13.01703 |
| 2010 | 236 | 450 | 14.35523 |
| 2011 | 223 | 673 | 13.56448 |
| 2012 | 234 | 907 | 14.23358 |
| 2013 | 243 | 1150 | 14.78102 |
| 2014 | 254 | 1404 | 15.45012 |
| 2015 | 240 | 1644 | 14.59854 |
| 2 Column name: | RN_INDI |
|---|---|
| Unique non-mission value count: | 547 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 2270 | 490782.2 | 487160 | 1010623 | 290056.7 |
| 3 Column name: | HME_YYYYMM |
|---|---|
| Unique non-mission value count: | 84 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 200901 | 201216.2 | 201210 | 201512 | 199.1095 |
| 4 Column name: | Q_PHX_DX_STK |
|---|---|
| Unique non-mission value count: | 2 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 0 | 1059 | 1059 | 64.416058 |
| 1 | 12 | 1071 | 0.729927 |
| NA | 573 | 1644 | 34.854015 |
| 5 Column name: | Q_PHX_DX_HTDZ |
|---|---|
| Unique non-mission value count: | 2 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 0 | 1052 | 1052 | 63.990268 |
| 1 | 26 | 1078 | 1.581508 |
| NA | 566 | 1644 | 34.428224 |
| 6 Column name: | Q_PHX_DX_HTN |
|---|---|
| Unique non-mission value count: | 2 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 0 | 864 | 864 | 52.55474 |
| 1 | 288 | 1152 | 17.51825 |
| NA | 492 | 1644 | 29.92701 |
| 7 Column name: | Q_PHX_DX_DM |
|---|---|
| Unique non-mission value count: | 2 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 0 | 1021 | 1021 | 62.104623 |
| 1 | 76 | 1097 | 4.622871 |
| NA | 547 | 1644 | 33.272506 |
| 8 Column name: | Q_PHX_DX_DLD |
|---|---|
| Unique non-mission value count: | 2 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 0 | 1035 | 1035 | 62.956204 |
| 1 | 43 | 1078 | 2.615572 |
| NA | 566 | 1644 | 34.428224 |
| 9 Column name: | Q_PHX_DX_PTB |
|---|---|
| Unique non-mission value count: | 2 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 0 | 915 | 915 | 55.656934 |
| 1 | 26 | 941 | 1.581508 |
| NA | 703 | 1644 | 42.761557 |
| 10 Column name: | Q_HBV_AG |
|---|---|
| Unique non-mission value count: | 3 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 1 | 77 | 77 | 4.6836983 |
| 2 | 1102 | 1179 | 67.0316302 |
| 3 | 463 | 1642 | 28.1630170 |
| NA | 2 | 1644 | 0.1216545 |
| 11 Column name: | Q_SMK_YN |
|---|---|
| Unique non-mission value count: | 3 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 1 | 995 | 995 | 60.5231144 |
| 2 | 256 | 1251 | 15.5717762 |
| 3 | 391 | 1642 | 23.7834550 |
| NA | 2 | 1644 | 0.1216545 |
| 12 Column name: | Q_DRK_FRQ_V09N |
|---|---|
| Unique non-mission value count: | 8 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 0 | 805 | 805 | 48.9659367 |
| 1 | 379 | 1184 | 23.0535280 |
| 2 | 249 | 1433 | 15.1459854 |
| 3 | 121 | 1554 | 7.3600973 |
| 4 | 28 | 1582 | 1.7031630 |
| 5 | 24 | 1606 | 1.4598540 |
| 6 | 15 | 1621 | 0.9124088 |
| 7 | 17 | 1638 | 1.0340633 |
| NA | 6 | 1644 | 0.3649635 |
| 13 Column name: | HGHT |
|---|---|
| Unique non-mission value count: | 51 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 134 | 164.5487 | 165 | 188 | 9.185884 |
| 14 Column name: | WGHT |
|---|---|
| Unique non-mission value count: | 81 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 31 | 65.09672 | 64 | 118 | 12.52964 |
| 15 Column name: | WSTC |
|---|---|
| Unique non-mission value count: | 57 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 57 | 80.68917 | 81 | 114 | 9.547019 |
| 16 Column name: | BMI |
|---|---|
| Unique non-mission value count: | 168 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 12.3 | 23.92257 | 23.7 | 37.2 | 3.378967 |
| 17 Column name: | VA_LT |
|---|---|
| Unique non-mission value count: | 16 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 0.1 | 0.9840024 | 1 | 9.9 | 0.5558351 |
| 18 Column name: | VA_RT |
|---|---|
| Unique non-mission value count: | 16 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 0.1 | 0.9791971 | 1 | 9.9 | 0.560936 |
| 19 Column name: | BP_SYS |
|---|---|
| Unique non-mission value count: | 87 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 81 | 122.2555 | 120 | 180 | 14.62929 |
| 20 Column name: | BP_DIA |
|---|---|
| Unique non-mission value count: | 62 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 49 | 76.59672 | 78 | 120 | 10.05631 |
| 21 Column name: | URN_PROT |
|---|---|
| Unique non-mission value count: | 5 |
| Missing value count: | 1 |
| cat | n | com_freq | percent |
|---|---|---|---|
| 1 | 1565 | 1565 | 95.1946472 |
| 2 | 38 | 1603 | 2.3114355 |
| 3 | 23 | 1626 | 1.3990268 |
| 4 | 12 | 1638 | 0.7299270 |
| 5 | 2 | 1640 | 0.1216545 |
| NA | 4 | 1644 | 0.2433090 |
| 22 Column name: | HGB |
|---|---|
| Unique non-mission value count: | 97 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 5.9 | 14.10572 | 14.1 | 18.3 | 1.691871 |
| 23 Column name: | FBS |
|---|---|
| Unique non-mission value count: | 106 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 61 | 97.22993 | 94 | 290 | 20.13323 |
| 24 Column name: | TOT_CHOL |
|---|---|
| Unique non-mission value count: | 189 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 68 | 194.9319 | 193 | 363 | 36.56853 |
| 25 Column name: | TG |
|---|---|
| Unique non-mission value count: | 332 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 13 | 134.9033 | 106 | 1210 | 104.7511 |
| 26 Column name: | HDL |
|---|---|
| Unique non-mission value count: | 83 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 23 | 55.90389 | 54 | 593 | 19.4672 |
| 27 Column name: | LDL |
|---|---|
| Unique non-mission value count: | 176 |
| Missing value count: | 1 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 19 | 118.688 | 112 | 8100 | 201.9903 |
| 28 Column name: | CRTN |
|---|---|
| Unique non-mission value count: | 30 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 0.4 | 0.9891119 | 0.9 | 16.5 | 1.01597 |
| 29 Column name: | SGOT |
|---|---|
| Unique non-mission value count: | 80 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 6 | 25.59793 | 23 | 459 | 16.17677 |
| 30 Column name: | SGPT |
|---|---|
| Unique non-mission value count: | 106 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 3 | 25.98297 | 20 | 779 | 27.17625 |
| 31 Column name: | GGT |
|---|---|
| Unique non-mission value count: | 151 |
| Missing value count: | 0 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 6 | 36.34002 | 24.5 | 408 | 36.42819 |
| 32 Column name: | GFR |
|---|---|
| Unique non-mission value count: | 120 |
| Missing value count: | 1 |
| Min | Mean | Median | Max | SD |
|---|---|---|---|---|
| 3 | 89.74172 | 87 | 196 | 21.70754 |